Remove Broken or un-published Link in Garden

#digital_garden #notes #markdown #static

My Question

When using dataview to list recently updated notes, it looks like non published notes are listed as well.

Is there any way to either

  1. skip over unpublished notes
  2. remove broken links

stalegjelsten Answer

Adding where dg-publish to your Dataview query would probably fix this.

TABLE dateformat(file.mtime, "dd.MM.yyyy - HH:mm") AS "Last modified"
FROM "mynotes"
WHERE dg-publish
SORT file.mtime DESC
LIMIT 10

If you would like to have all your notes listed in Obsidian, but only show the published notes in the dataview tables in your digital garden you can use the following "hack".

In your dataview queries, add a line containing WHERE file.mtime in a separate line, e.g.

TABLE dateformat(file.mtime, "dd.MM.yyyy - HH:mm") AS "Last modified"
FROM "mynotes"
WHERE file.mtime
SORT file.mtime DESC
LIMIT 10

(It doesn't need to be file.mtime, but choose something which matches all notes, but at the same time is not something you would ever add an actual where filter for).

Then you can use a Digital garden custom filter which replaces WHERE file.mtime with WHERE dg-publish 👇

|

file.mtime$ where dg-publish gm

Credits